Easy2Siksha.com
GNDU Question Paper-2025
Bachelor of Computer Application (BCA) (Hons.)
1" Semester (Batch 2024-28) (CBGS)
COMPUTER FUNDAMENTALS & PC SOFTWARE
Time Allowed: Three Hours Max. Marks: 75
Note: Attempt Five questions in all, selecting at least One question from each section. The
Fifth question may be attempted from any section. All questions carry equal marks.
SECTION-A
1. Write an elaborate note on the generations of computers. How has the classification of
computers changed from the first generation to the fifth generation in terms of technology,
processing speed. storage capacity, and applications?
2. Modern communication relies heavily on devices like smartphones and satellite communication
systems. Explain how these devices work, the technologies behind them, and how they have
transformed global communication in terms of speed, cost, and accessibility.
SECTION-B
3. Explain the working of the following:
(a) Screen assisted data entry devices
(b) Impact Printer
4.(a) What do you mean by Optical storage? How can data be stored on an optical storage device?
(b). Differentiate between HDD (1 lard Disk Drive) and SSD (Solid State Drive).
SECTION-C
Easy2Siksha.com
5. (a) What is the purpose of an operating system? What are the different types of Operating
systems working in your Computer Lab?
(b) Describe the working of File Explorer in detail.
6. (a) Explain the process of inserting tables in a document and then create a graph of that table
using a suitable example.
(b) How can one insert Header and Footer in a document? Explain with an example.
SECTION-D
7. Create a PowerPoint presentation of your department. Add animations to objects in it using
different formatting styles.
8. (a) How do you create a chart using a set of data in Excel?
(b) Explain the purpose of a Pivot Table. How can it be used to analyze data?
Easy2Siksha.com
GNDU Answer Paper-2025
Bachelor of Computer Application (BCA) (Hons.)
1" Semester (Batch 2024-28) (CBGS)
COMPUTER FUNDAMENTALS & PC SOFTWARE
Time Allowed: Three Hours Max. Marks: 75
Note: Attempt Five questions in all, selecting at least One question from each section. The
Fifth question may be attempted from any section. All questions carry equal marks.
SECTION-A
1. Write an elaborate note on the generations of computers. How has the classification of
computers changed from the first generation to the fifth generation in terms of
technology, processing speed. storage capacity, and applications?
Ans: Computers have become one of the most important inventions in human history.
Today, we use computers everywhere — in schools, banks, hospitals, offices, mobile
phones, railway stations, shopping malls, and even at home. But computers were not always
small, fast, and smart like they are today. In the beginning, computers were huge machines
that occupied entire rooms and worked very slowly compared to modern computers.
The development of computers is divided into different stages called “Generations of
Computers.” Each generation shows how computer technology improved over time in
terms of size, speed, storage capacity, reliability, and applications.
Generations of Computers
The history of computers is mainly divided into five generations:
1. First Generation Computers
2. Second Generation Computers
3. Third Generation Computers
4. Fourth Generation Computers
5. Fifth Generation Computers
Easy2Siksha.com
Simple Diagram of Computer Generations
First Generation → Vacuum Tubes
Second Generation → Transistors
Third Generation → Integrated Circuits (ICs)
Fourth Generation → Microprocessors
Fifth Generation → Artificial Intelligence (AI)
1. First Generation Computers (1940 – 1956)
The first generation computers used Vacuum Tubes as the main electronic component.
What are Vacuum Tubes?
Vacuum tubes were electronic devices used to control electricity. They were very large and
produced a lot of heat.
Examples:
• ENIAC
• UNIVAC
• EDVAC
Features of First Generation Computers
1. Technology Used
• Vacuum tubes were used for processing.
• Magnetic drums were used for memory.
2. Size
• Computers were extremely huge.
• They occupied an entire room.
3. Processing Speed
• Very slow compared to modern computers.
• Calculations took a lot of time.
4. Storage Capacity
• Very limited storage.
• Data storage was poor.
Easy2Siksha.com
5. Power Consumption
• Consumed huge amounts of electricity.
6. Heat Production
• Produced excessive heat.
• Needed air conditioning.
7. Applications
Used mainly for:
• Scientific calculations
• Military purposes
• Government work
Drawbacks
• Very expensive
• Difficult to maintain
• Slow speed
• Large size
2. Second Generation Computers (1956 – 1963)
The second generation replaced vacuum tubes with Transistors.
What is a Transistor?
A transistor is a small electronic device used to control electrical signals. It is much smaller
and faster than a vacuum tube.
Features of Second Generation Computers
1. Technology Used
• Transistors replaced vacuum tubes.
2. Size
• Smaller than first generation computers.
Easy2Siksha.com
3. Processing Speed
• Faster processing speed.
4. Storage Capacity
• Improved memory and storage.
5. Reliability
• More reliable and accurate.
6. Heat Production
• Produced less heat.
7. Applications
Used in:
• Business organizations
• Universities
• Scientific research
Advantages Over First Generation
Improvement
Explanation
Smaller Size
Easier to handle
Faster Speed
Better calculations
Less Heat
More efficient
Lower Cost
More affordable
3. Third Generation Computers (1964 – 1971)
The third generation introduced Integrated Circuits (ICs).
What is an Integrated Circuit?
An IC is a small chip containing many transistors on a single silicon chip.
This invention completely changed the computer world.
Features of Third Generation Computers
Easy2Siksha.com
1. Technology Used
• Integrated Circuits (ICs)
2. Size
• Much smaller and compact.
3. Processing Speed
• Very fast compared to earlier generations.
4. Storage Capacity
• Better storage devices developed.
5. Reliability
• Highly reliable.
6. User Interaction
• Keyboards and monitors started being used.
7. Applications
Used in:
• Banking
• Education
• Industries
• Commercial work
Major Improvements
• Multiprogramming became possible.
• Operating systems improved.
• Computers became easier to use.
4. Fourth Generation Computers (1971 – Present)
The fourth generation introduced the Microprocessor.
What is a Microprocessor?
Easy2Siksha.com
A microprocessor is a complete CPU built on a single chip.
This invention made personal computers possible.
Features of Fourth Generation Computers
1. Technology Used
• Microprocessors
2. Size
• Very small and portable.
3. Processing Speed
• Extremely fast.
4. Storage Capacity
• Huge storage capacity.
5. Cost
• Affordable for common people.
6. Reliability
• Very reliable and durable.
7. Applications
Used almost everywhere:
• Homes
• Offices
• Schools
• Hospitals
• Entertainment
• Internet
Examples
• Desktop computers
Easy2Siksha.com
• Laptops
• Smartphones
5. Fifth Generation Computers (Present and Future)
The fifth generation is based on Artificial Intelligence (AI).
What is Artificial Intelligence?
Artificial Intelligence means machines that can think, learn, and make decisions like humans.
Examples include:
• Chatbots
• Robots
• Virtual assistants
• Self-driving cars
Features of Fifth Generation Computers
1. Technology Used
• Artificial Intelligence
• Machine Learning
• Robotics
• Quantum Computing
2. Processing Speed
• Extremely high speed.
3. Storage Capacity
• Massive storage capability.
4. Intelligence
• Computers can learn and solve problems.
5. Applications
Used in:
• Medical science
Easy2Siksha.com
• Space research
• Robotics
• Online learning
• Smart devices
Classification Changes from First to Fifth Generation
Now let us understand how computers changed generation by generation.
Feature
First
Generation
Second
Generation
Third
Generation
Fourth
Generation
Technology
Vacuum
Tubes
Transistors
ICs
Microprocessors
Size
Very Large
Smaller
Compact
Very Small
Speed
Slow
Faster
Very Fast
Extremely Fast
Storage
Very Low
Improved
Better
Huge
Heat
Very High
Less
Low
Very Low
Cost
Very
Expensive
Cheaper
Affordable
Low Cost
Applications
Scientific
Work
Business
Commercial
Use
Personal Use
Overall Development of Computers
The journey from first generation to fifth generation shows tremendous improvement:
1. Technology Improved
Vacuum tubes evolved into AI and smart systems.
2. Size Became Smaller
Room-sized computers became pocket-sized smartphones.
3. Speed Increased
Modern computers can perform billions of calculations in seconds.
4. Storage Capacity Expanded
Today we can store huge amounts of data in tiny devices.
5. Applications Increased
Easy2Siksha.com
Earlier computers were only for scientists, but now everyone uses computers daily.
Conclusion
The generations of computers show the amazing progress of science and technology. From
huge machines using vacuum tubes to modern intelligent AI systems, computers have
changed the world completely. Each generation brought improvements in speed, size,
storage, reliability, and usability.
Today, computers are faster, smarter, smaller, and more powerful than ever before. The
future of computers will become even more advanced with Artificial Intelligence, robotics,
and quantum computing. Understanding computer generations helps us appreciate how
technology has evolved and how it continues to shape our daily lives.
2. Modern communication relies heavily on devices like smartphones and satellite
communication systems. Explain how these devices work, the technologies behind them,
and how they have transformed global communication in terms of speed, cost, and
accessibility.
Ans: Imagine standing on a busy street corner in New York and deciding, on a whim, to see
your friend's face who is sitting in a cafe in Tokyo. You pull a small slab of glass and metal
from your pocket, tap the screen a few times, and within seconds, you are looking at them
live, in high definition, halfway across the globe.
We do this every day without a second thought. But if you pause to consider what actually
happens when you hit "call," it feels less like technology and more like absolute magic. Yet,
it isn't magic at all. It is a carefully orchestrated dance of physics, engineering, and invisible
waves.
Here is the story of how our modern world stays connected.
The Magic in Your Pocket: How Smartphones Work
Let’s start with the device in your hand. At its core, your smartphone is not really a phone in
the traditional sense; it is an incredibly sophisticated two-way radio.
When you speak into it, a tiny microphone converts the sound waves of your voice into a
digital electrical signal—a long string of computer code made of ones and zeros. The
phone’s internal antenna takes that digital code and broadcasts it outward as invisible
electromagnetic radio waves. These waves are exactly like the light we see with our eyes,
just at a frequency our eyes cannot detect.
Easy2Siksha.com
But your phone’s internal radio isn't strong enough to blast a signal all the way to Tokyo, or
even to the next town over. It only needs to be strong enough to reach the nearest cell
tower. This is where the concept of a "cellular" network comes in.
Imagine your city divided into a giant, invisible honeycomb grid. Each hexagon in that grid is
a "cell," and right in the middle of each cell sits a towering antenna mast. When you make a
call, your phone searches for the closest tower and connects to it. As you move—say,
driving down the highway—your phone constantly monitors the signal strength. When you
reach the edge of one cell, the network seamlessly "hands off" your connection to the tower
in the next cell. This happens in a fraction of a second, without dropping your call.
Once your signal reaches the local cell tower, it generally stops being wireless. The tower
sends your digital voice down into the ground, where it hits a massive, high-speed network
of fiber-optic cables. These cables use ultra-fast pulses of light to transmit data. They form
the true, physical backbone of the internet, running under cities, across continents, and
deep across the ocean floor until they reach a cell tower in Tokyo, which broadcasts the
signal wirelessly to your friend's phone.
The Eye in the Sky: Satellite Communication
Cell towers are brilliant, but they only work where humans have built them. What if you are
on a ship in the middle of the Pacific Ocean, or hiking deep in the Himalayas? There are no
fiber-optic cables or cell masts there. That is where satellite communication steps in to
bridge the gap.
If cell towers are local relay stations, satellites are the ultimate global relay stations, parked
high up in space.
When you use a satellite phone or a modern satellite internet dish, your device beams a
highly focused radio signal straight up into the sky. High above the Earth, a satellite catches
that signal. The satellite acts like a giant, intelligent mirror in space. It receives your
message, amplifies it so the signal doesn't degrade, and beams it back down to a massive
ground station dish somewhere else on Earth.
To see what it takes to bounce signals from space, explore the anatomy of a
communications satellite here:
Generating interactive visual...Preparing high-resolution details
There are two main ways we use these space-based routers today:
Easy2Siksha.com
• Geostationary Satellites: These sit about 22,000 miles above the equator. They orbit
the Earth at the exact same speed the Earth spins, meaning they appear to hover
perfectly still over one spot. They cover massive areas, but because the radio waves
have to travel 44,000 miles round-trip, there is a noticeable delay, or latency, in the
signal.
• Low Earth Orbit (LEO) Satellites: This is the newer technology powering networks
like Starlink. These satellites fly much closer to Earth—just a few hundred miles up.
Because they are closer, the signal is incredibly fast with almost zero delay. But since
they are zooming around the globe at 17,000 miles per hour, you need thousands of
them working together in a "constellation." As soon as one flies out of range,
another one is right behind it to seamlessly catch your signal.
The Technologies Powering the Magic
None of this infrastructure would work without a few incredible leaps in underlying
technology hidden inside your devices:
• Microprocessors: The brain of your phone. Decades ago, the computing power
required to encode and decode live video would have filled an entire room. Today, it
fits on a silicon chip the size of your fingernail.
• Advanced Antennas: Your phone doesn't just have one antenna; it has several,
constantly switching and tuning themselves to grab different frequencies without
dropping the connection.
• Digital Compression: Before your voice or video is sent, complex software
algorithms compress the data, stripping away unnecessary bits so the file is tiny and
easy to send, then instantly rebuilding it on the other side.
The Great Transformation
Easy2Siksha.com
This invisible infrastructure of towers, cables, and satellites has completely rewired human
existence. It has transformed global communication in three fundamental ways:
1. The Death of Distance (Speed)
Historically, information traveled only as fast as a horse, a ship, or a train. A letter from
London to New York took weeks. Even early telegraphs and long-distance phone calls
required manual routing through switchboards. Today, speed is instantaneous. We expect
immediate answers, live video, and real-time collaboration with colleagues on different
continents, drastically accelerating global business and culture.
2. The Economics of Abundance (Cost)
In the 1980s and 90s, an international phone call could cost dollars per minute. People kept
egg timers by the phone to make sure they didn't go bankrupt talking to relatives abroad.
Today, because we transmit data digitally over massive, efficient networks, the marginal
cost of sending a message or video call is virtually zero.
3. The Democratization of Knowledge (Accessibility)
This is perhaps the greatest shift of all. You no longer need to be tied to a desk or a landline
in a wealthy nation to be connected to the world. A farmer in rural Kenya with a cheap
smartphone has access to the exact same global market data, weather forecasts, and
educational resources as a stockbroker in Manhattan. Satellite internet is pushing this even
further, ensuring that literally no corner of the globe is cut off from human conversation.
SECTION-B
3. Explain the working of the following:
(a) Screen assisted data entry devices
(b) Impact Printer
Ans: Part 1: Screen-Assisted Data Entry Devices (The Guided Input)
To understand why "screen-assisted" data entry is special, you have to imagine what
computing was like before it existed. In the early days, entering data meant punching holes
into stiff paper cards, or typing raw lines of code into a dark, blank terminal. If you made a
single typo, you often wouldn't know until the computer ran the program and spat out an
error. It was frustrating, slow, and completely blind.
Screen-assisted data entry changed everything by turning the computer screen into an
active, helpful guide.
How It Works
Easy2Siksha.com
A screen-assisted data entry device is essentially any system where a visual display (the
screen) actively prompts the user, formats the workspace, and often checks the information
as it is being entered via an input device (like a keyboard, mouse, or touch screen).
Here is the step-by-step breakdown of how this interactive loop works:
1. The Visual Framework (The Form): Instead of a blank screen, the software generates
a structured layout. Think of an online shopping checkout page. You see specific,
labeled boxes called "fields"—one for your First Name, one for your Zip Code, one
for your Credit Card Number.
2. The Prompt: The screen explicitly tells you what it expects. It might highlight the
active box or provide a blinking cursor so you know exactly where your typing will
go.
3. The Input Methods: While keyboards are standard, the "assist" part often involves
making data entry easier. Instead of typing a state, the screen gives you a drop-down
menu to click. Instead of typing "Yes" or "No," it gives you radio buttons or
checkboxes.
4. Real-Time Validation (The Magic Step): This is the most crucial part of the "assist."
As you type, the software is actively watching. If you try to type the letter "A" into a
phone number field, the screen will immediately block it, flash red, or pop up a
warning message saying, "Please enter numbers only."
Why is this important?
Think of this system like a highly attentive librarian standing over your shoulder. It prevents
"garbage in, garbage out." By catching human errors immediately, it ensures that the
database only receives clean, formatted, and useful information.
Everyday Examples:
• ATMs: The screen guides you through every step (Withdrawal -> Checking ->
Amount) and won't let you ask for $500 if you only have $50.
• Point of Sale (POS) Systems: The touchscreens used by cashiers at grocery stores or
baristas at coffee shops. The screen assists them by displaying pictures of items,
automatically calculating tax, and guiding the payment process.
• Self-Checkout Kiosks: These systems use the screen to assist you in scanning,
bagging, and paying, complete with visual instructions and error alerts if something
goes wrong in the bagging area.
Part 2: Impact Printers (The Mechanical Output)
Now let's switch gears from putting data in, to getting it out. If modern laser printers are like
silent ninjas, using light and static electricity to quietly fuse powder to a page, Impact
Printers are the heavy-metal drummers of the computing world. They are loud, mechanical,
and highly physical.
How It Works
Easy2Siksha.com
An impact printer works exactly how it sounds: it makes a mark by physically striking the
paper. The core mechanism is heavily inspired by the classic mechanical typewriter.
Here is the anatomy of an impact printer at work:
1. The Paper Feed: These printers usually use continuous "tractor-feed" paper. This is a
long, continuous stack of paper with perforated edges and little holes along the
sides. Gears with pins lock into these holes to pull the paper through the machine
with extreme precision.
2. The Ink Ribbon: Just in front of the paper sits a long, cloth ribbon that is
continuously soaked in wet ink.
3. The Print Head (The Striker): This is the heart of the machine. The print head sits on
a metal rail and slides rapidly back and forth across the page. In the most common
type of impact printer—the Dot Matrix Printer—this print head contains a vertical
column of tiny, needle-like metal pins.
4. The Impact: When the computer tells the printer to create the letter "H," the print
head slides into position. Tiny electromagnets inside the head fire specific pins
forward. These pins smash into the ink ribbon, which in turn presses into the paper,
leaving a pattern of tiny ink dots that form the letter "H".
Because the print head is physically slamming metal pins against a ribbon and paper
hundreds of times a second, these printers make a very distinct, loud, screeching, and
buzzing noise.
Why do we still use them?
You might wonder why anyone would use a loud, slow, low-resolution impact printer when
we have cheap, silent, high-definition inkjet and laser printers today. The answer comes
down to one unique physical property: Force.
Because an impact printer physically strikes the page, it is the only type of printer that can
print on multi-part carbon copy forms.
If you go to an auto repair shop, a car rental desk, or a shipping warehouse, you will often
see them printing invoices on special paper that has a white top copy, a yellow middle copy,
and a pink bottom copy. When the impact printer's pins strike the top page, the physical
pressure transfers the ink through the carbon layers onto the yellow and pink pages
beneath it simultaneously. A laser printer simply sprays ink on the top sheet, leaving the
bottom sheets blank.
Furthermore, impact printers are incredibly rugged. They can operate perfectly in dusty
warehouses, hot factories, and greasy auto shops where a delicate laser printer would
quickly break down.
Summary
In the grand conversation between humans and computers, these two technologies
represent vital bridges. Screen-assisted data entry devices hold our hands, visually guiding
Easy2Siksha.com
us to ensure the information we give the computer is accurate and clean. On the flip side,
impact printers use raw, mechanical force to punch that data back out into the physical
world, creating durable, multi-layered records that modern technology simply cannot
replicate.
4.(a) What do you mean by Optical storage? How can data be stored on an optical storage
device?
(b). Differentiate between HDD (1 lard Disk Drive) and SSD (Solid State Drive).
Ans: 5(a) What do you mean by Optical Storage? How can data be stored on an optical
storage device?
In the modern world, computers store huge amounts of information such as photos, videos,
songs, software, documents, and games. To save this information permanently, different
storage devices are used. One important type of storage is Optical Storage.
Meaning of Optical Storage
Optical storage is a method of storing data using laser light technology. In this type of
storage, a laser beam reads and writes data on a shiny circular disc.
Common examples of optical storage devices are:
• CD (Compact Disc)
• DVD (Digital Versatile Disc)
• Blu-ray Disc
These discs are made of plastic material and coated with a reflective metallic surface.
Simple Understanding of Optical Storage
Suppose you have a music CD. When you insert it into a computer or CD player, a laser
beam inside the device reads the information stored on the disc and plays the music.
So, optical storage works with the help of:
1. Laser light
2. Spinning disc
3. Reflection of light
The computer understands data based on how the laser light reflects from the surface of
the disc.
Easy2Siksha.com
How Data is Stored on an Optical Storage Device
Data is stored on the disc in the form of very tiny marks called:
• Pits → small dents
• Lands → flat shiny areas
These pits and lands are arranged in spiral tracks on the disc surface.
When the laser beam falls on the disc:
• Lands reflect light properly
• Pits scatter the light
The computer detects these reflections and converts them into binary data:
• 1 = reflected light
• 0 = no reflection
This is how songs, videos, files, and software are stored and read.
Step-by-Step Working of Optical Storage
Step 1: Disc Spins
The optical disc rotates at high speed inside the drive.
Step 2: Laser Beam Reads Surface
A laser beam focuses on the disc surface.
Step 3: Reflection is Detected
The sensor checks whether the light is reflected or not.
Step 4: Data Conversion
The device converts reflected signals into binary numbers (0s and 1s).
Step 5: Information is Displayed
Finally, the computer shows the stored file, music, or video.
Diagram of Optical Storage
Easy2Siksha.com
Optical Disc Surface
--------------------------------
/ \
| Lands Pits Lands Pits |
| ____ __ ____ __ |
|___| |__| |____| |__| |___|
\ /
--------------------------------
↑
Laser Beam
Advantages of Optical Storage
1. Easy to carry
2. Low cost
3. Good for storing movies and songs
4. Long life if handled carefully
5. Portable and lightweight
Disadvantages of Optical Storage
1. Slower than modern storage devices
2. Can be scratched easily
3. Limited storage capacity
4. Needs an optical drive
5(b) Difference Between HDD and SSD
Both HDD and SSD are storage devices used in computers to save data permanently. But
their technology and performance are very different.
What is HDD?
HDD stands for Hard Disk Drive.
It stores data using magnetic technology. Inside an HDD, there are spinning disks called
platters and a moving arm that reads and writes data.
It works somewhat like an old music record player.
Easy2Siksha.com
What is SSD?
SSD stands for Solid State Drive.
It stores data using flash memory chips. It has no moving parts.
SSD works like a large pen drive but much faster and more powerful.
Simple Comparison
Imagine:
• HDD = Old scooter
• SSD = Modern sports bike
Both can take you to the destination, but SSD is much faster and smoother.
Diagram of HDD and SSD
HDD Structure
-----------------------
| Spinning Platters |
| ○ ○ ○ |
| Read Arm → |
-----------------------
SSD Structure
-----------------------
| Memory Chips |
| [■] [■] [■] [■] |
| No Moving Parts |
-----------------------
Difference Between HDD and SSD
Basis
HDD
SSD
Full Form
Hard Disk Drive
Solid State Drive
Technology
Magnetic storage
Flash memory
Speed
Slower
Very fast
Moving Parts
Yes
No
Noise
Makes noise
Silent
Easy2Siksha.com
Durability
Less durable
More durable
Power Consumption
More
Less
Weight
Heavy
Lightweight
Price
Cheaper
Costlier
Boot Time
Slow
Fast
Advantages of HDD
1. Less expensive
2. Large storage at low price
3. Good for storing bulk data
Advantages of SSD
1. Very fast performance
2. Faster booting of computer
3. No noise
4. Less heat generation
5. More durable
Conclusion
Optical storage is a laser-based technology used to store data on discs like CDs and DVDs.
Data is stored in the form of pits and lands that are read using laser beams.
On the other hand, HDD and SSD are modern storage devices used in computers. HDD uses
magnetic spinning disks, while SSD uses flash memory chips. SSD is faster, quieter, and more
reliable, whereas HDD is cheaper and offers larger storage capacity at lower cost.
Today, SSDs are becoming more popular because of their high speed and better
performance, while optical storage is mainly used for media storage and backups.
SECTION-C
5. (a) What is the purpose of an operating system? What are the different types of
Operating systems working in your Computer Lab?
(b) Describe the working of File Explorer in detail.
Easy2Siksha.com
Ans: (a) Purpose of an Operating System and Types of Operating Systems Used in
Computer Labs
A computer is like a smart machine, but without an Operating System (OS), it cannot work
properly. The Operating System is the most important software of a computer because it
acts as a bridge between the user and the hardware. It controls all the activities of the
computer and helps different programs run smoothly.
We can understand the Operating System by comparing it to a school principal. Just as the
principal manages teachers, students, classrooms, and school activities, the operating
system manages the computer’s memory, files, software, and hardware devices.
Some popular examples of Operating Systems are:
• Microsoft Windows
• Linux
• macOS
• Android
Main Purposes of an Operating System
1. Managing Hardware
The operating system controls hardware devices such as:
• Keyboard
• Mouse
• Printer
• Monitor
• Hard disk
For example, when we click the mouse, the OS understands the action and shows the result
on the screen.
2. Running Software Programs
Whenever we open software like MS Word, Paint, or a web browser, the operating system
loads the program into memory and allows it to run.
3. File Management
The OS stores, organizes, and manages files and folders. It helps users save, copy, rename,
delete, and search files easily.
4. Memory Management
The operating system controls the computer memory (RAM). It decides how much memory
each program needs.
Easy2Siksha.com
5. Providing Security
The OS protects data through passwords, user accounts, and security settings.
6. User Interface
The operating system provides a user-friendly environment so users can interact with the
computer using icons, menus, and windows.
Types of Operating Systems Used in Computer Labs
Different computer labs may use different operating systems depending on their needs.
1. Windows Operating System
Most school and college computer labs use Windows because it is easy to learn and user-
friendly.
Features:
• Attractive graphical interface
• Easy file handling
• Supports many software programs
Examples:
• Windows 10
• Windows 11
2. Linux Operating System
Some labs use Linux because it is free and secure.
Features:
• Open-source
• Fast performance
• Less affected by viruses
Examples:
• Ubuntu
• Fedora
3. macOS
Easy2Siksha.com
Used mainly in Apple computers.
Features:
• Smooth performance
• Strong security
• High-quality graphics support
Simple Diagram of Operating System
USER
│
▼
OPERATING SYSTEM
┌────────┼────────┐
▼ ▼ ▼
Hardware Files Software
This diagram shows that the operating system connects the user with all parts of the
computer.
(b) Working of File Explorer
File Explorer is an important feature in Windows Operating System. It helps users view and
manage files, folders, and drives stored in the computer.
Earlier, it was called “Windows Explorer.” It works like a digital cupboard where all files and
folders are organized properly.
The shortcut key to open File Explorer is:
Windows Key + E
Main Functions of File Explorer
1. Viewing Files and Folders
File Explorer allows users to see all stored data such as:
• Documents
• Images
• Videos
• Music
Easy2Siksha.com
• Downloads
Everything is displayed in an organized manner.
2. Creating New Folders
Users can create folders to keep files arranged properly.
Example:
A student may create separate folders like:
• Notes
• Assignments
• Projects
This helps in easy searching.
3. Copying and Moving Files
File Explorer allows users to:
• Copy files from one place to another
• Move files between folders
• Transfer data to pen drives
4. Renaming Files
Users can change file names easily according to their needs.
Example:
Assignment1.docx → English_Assignment.docx
5. Deleting Files
Unwanted files can be deleted through File Explorer. Deleted files usually go to the Recycle
Bin.
6. Searching Files
Easy2Siksha.com
If users forget where a file is saved, they can use the search bar in File Explorer to find it
quickly.
7. Managing Drives
File Explorer displays different drives such as:
• C Drive
• D Drive
• USB Drive
Users can open and manage storage devices from here.
Parts of File Explorer Window
1. Navigation Pane
Located on the left side. It shows folders and drives.
2. Address Bar
Shows the location of the current folder.
3. Search Box
Used to search files and folders.
4. File Display Area
Displays the contents of the selected folder.
Diagram of File Explorer
-------------------------------------------------
| Address Bar | Search Box |
-------------------------------------------------
| Navigation Pane | Files and Folders Area |
| | |
| Desktop | Document1.docx |
| Downloads | Photo.jpg |
| This PC | Video.mp4 |
| Local Disk (C:) | |
-------------------------------------------------
Easy2Siksha.com
Conclusion
The Operating System is the backbone of a computer because it controls all hardware and
software activities. Without it, a computer cannot function properly. Operating systems like
Windows, Linux, and macOS are commonly used in computer labs.
File Explorer is a useful tool provided by the operating system that helps users organize and
manage files and folders efficiently. It makes computer work easier, faster, and more
organized for students and everyday users.
6. (a) Explain the process of inserting tables in a document and then create a graph of that
table using a suitable example.
(b) How can one insert Header and Footer in a document? Explain with an example.
Ans: Part 1: The Magic of Tables (Organizing the Chaos)
Imagine you are doing a science experiment on how fast different plants grow depending on
what you feed them. You are testing water, orange juice, and milk.
If you try to explain your results in a paragraph, it might look like this: "In week one, the
water plant grew 2 inches, the juice plant grew 1 inch, and the milk plant grew 0.5 inches.
Then in week two, the water plant grew 4 inches..." By the time someone finishes reading
that, they will be completely confused! Your brain has to work too hard to remember all
those numbers. This is where Tables come to the rescue. A table is like a neat little filing
cabinet for your data. It organizes information into a grid of horizontal Rows (like rows of
seats in a movie theater) and vertical Columns (like the tall pillars holding up a building). The
little boxes where rows and columns meet are called Cells.
How to Insert a Table:
Whether you are using Microsoft Word or Google Docs, the process is wonderfully simple:
1. Find the perfect spot: Click your mouse exactly where you want the table to appear
in your document.
2. Go to the menu: Look at the top of your screen and click on the "Insert" tab.
3. Choose your grid: Click on "Table." A little grid of squares will pop up. You simply
drag your mouse over the squares to choose how big you want your table to be. For
our plant experiment, we might want 4 columns (Time, Water, Juice, Milk) and 3
rows (Week 1, Week 2, Week 3).
4. Fill it in: Once the table appears on your page, you just click inside the empty boxes
and start typing your numbers!
Part 2: Turning Tables into Graphs (Painting a Picture with Numbers)
Tables are fantastic, but humans are highly visual creatures. We love pictures. While a table
tells us the numbers, a Graph (or Chart) shows us the story those numbers are trying to tell.
Easy2Siksha.com
If we take our plant table and turn it into a graph, we can instantly see the lines zooming up
or crashing down. It makes the data exciting and instantly understandable.
How to Create a Graph from Your Table:
1. Highlight your data: Click and drag your mouse over your entire table to select all
the numbers and words you just typed.
2. Insert the Chart: Go back up to that trusty "Insert" menu at the top of your screen.
This time, click on "Chart" (in Word, you might click Insert > Chart, while in Google
Docs you click Insert > Chart > From Sheets, or just create it directly).
3. Pick your style: You will be asked what kind of graph you want. For showing plant
growth over time, a Line Graph is perfect because it shows a journey. If you were
comparing favorite ice cream flavors, a Pie Chart would be better.
4. Watch the magic: The software will automatically read the numbers from your table
and generate a colorful graph!
Part 3: Headers and Footers (The Hat and Shoes of Your Document)
Now that the inside of your document looks amazing with its new tables and graphs, we
need to think about the edges of the paper.
Imagine you print out your brilliant 10-page plant experiment report. You are walking down
the school hallway, you trip, and the pages go flying everywhere! When you pick them up,
they are totally out of order. Because there are no page numbers, you have no idea how to
put them back together.
This is why we need Headers and Footers.
• The Header is the space at the very, very top margin of the page (like a hat).
• The Footer is the space at the very, very bottom margin of the page (like a pair of
shoes).
The magical thing about Headers and Footers is that whatever you type in them will
automatically repeat on every single page of your document. You only have to type it once!
How to Insert them (With an Example):
Let’s say we want to make sure your name is on every page, and we want page numbers so
you never lose track of the order.
1. The Double-Click Trick: The easiest way to open the header is to move your mouse
to the blank white space at the very top of your document and quickly double-click.
(Alternatively, you can go to the "Insert" menu and click "Header & Footer").
2. Dress the top (Header): The main text of your document will turn a bit gray, and the
top margin will open up. Type your title and name: "The Great Plant Experiment - By
Alex Student." Now, that text will proudly sit at the top of pages 1, 2, 3, and so on.
3. Dress the bottom (Footer): Scroll down to the bottom of the page and click inside
the Footer area. We want page numbers here. Don't just type the number "1", or
Easy2Siksha.com
every page will say "1"! Instead, go to the menu at the top, find "Page Number," and
select where you want it to sit (like the bottom right corner). The computer will
automatically calculate the numbers for you: 1, 2, 3, 4.
Putting it All Together
By using these three simple tools, you have completely transformed your work. You used a
Table to organize messy data into a clean grid. You used a Graph to turn that grid into a
colorful, easy-to-understand picture. Finally, you used a Header and Footer to give your
document a professional frame, ensuring your name is always visible and your pages are
always in order.
SECTION-D
7. Create a PowerPoint presentation of your department. Add animations to objects in it using
different formatting styles.
Ans: Create a PowerPoint Presentation of Your Department and Add Animations
The question is asking you to create a PowerPoint presentation (PPT) about your
department and make it attractive by using animations and formatting styles. In simple
words, you have to prepare a slideshow that introduces your department in a professional
and creative way.
A PowerPoint presentation is a collection of slides used to present information in an
organized and visual manner. It is commonly used in schools, colleges, offices, and seminars.
In this task, you must use Microsoft PowerPoint to explain your department and apply
different design and animation effects to make the presentation more engaging.
Understanding the Main Concepts in the Question
The question contains three important parts:
1. Create a PowerPoint presentation
2. Present information about your department
3. Add animations and formatting styles
Let us understand each part one by one.
1. What is a PowerPoint Presentation?
Easy2Siksha.com
A PowerPoint presentation is a digital slide show made using Microsoft PowerPoint
software. Each page in PowerPoint is called a “slide.” These slides can contain:
• Text
• Images
• Charts
• Shapes
• Videos
• Tables
• Animations
The main purpose of a presentation is to explain information clearly and visually.
For example, if your department is Computer Science, your slides may include:
• Introduction to the department
• Faculty members
• Courses offered
• Laboratories
• Achievements
• Future opportunities
2. What is Meant by “Your Department”?
Your department means the academic subject or branch in which you study.
Examples:
• Computer Science Department
• Commerce Department
• Physics Department
• Sociology Department
• Fine Arts Department
You have to give basic and useful information about your own department.
3. What are Animations?
Animations are moving effects added to objects in PowerPoint. They make the presentation
more attractive and interactive.
Objects can be:
• Text
Easy2Siksha.com
• Pictures
• Shapes
• Titles
• Charts
When animation is applied, the object can:
• Appear slowly
• Fly from one side
• Zoom in
• Bounce
• Fade away
Animations help keep the audience interested.
Types of Animations in PowerPoint
There are mainly four types of animations:
(A) Entrance Animation
This effect controls how an object enters the slide.
Examples:
• Fade
• Fly In
• Zoom
Example:
A title slowly appearing on the screen.
(B) Emphasis Animation
This effect highlights an object already present on the slide.
Examples:
• Pulse
• Spin
• Grow/Shrink
Example:
An image enlarging slightly to attract attention.
Easy2Siksha.com
(C) Exit Animation
This effect controls how an object leaves the slide.
Examples:
• Fade Out
• Fly Out
• Disappear
(D) Motion Path Animation
This moves an object from one place to another.
Example:
A logo moving across the slide.
What are Formatting Styles?
Formatting styles improve the appearance of the presentation. They help make slides
beautiful, readable, and professional.
Formatting includes:
• Font style
• Font size
• Font color
• Background design
• Text alignment
• Themes
• Borders
• Shapes
For example:
• Using bold headings
• Adding colorful backgrounds
• Using professional themes
Steps to Create the Presentation
Easy2Siksha.com
Step 1: Open Microsoft PowerPoint
Start PowerPoint and choose a blank presentation.
Step 2: Create the Title Slide
Add:
• Department Name
• College Name
• Your Name
• Roll Number
Example:
“Department of Computer Applications”
Step 3: Add Information Slides
You can create slides like:
Slide Number
Content
1
Introduction
2
About the Department
3
Courses Offered
4
Faculty Members
5
Laboratories and Facilities
6
Achievements
7
Career Opportunities
8
Thank You Slide
Simple Diagram of a PowerPoint Structure
POWERPOINT PRESENTATION
│
┌──────────────────────────────────────────┐
│ │
Title Slide Content Slides
│ │
Department Name Introduction, Courses,
College Name Faculty, Achievements
│ │
└──────────────→ Animations & Formatting ←──────────────┘
Easy2Siksha.com
How to Add Animations
Follow these steps:
1. Select the object (text or image)
2. Click the “Animations” tab
3. Choose an animation effect
4. Adjust timing and speed
Example:
• Apply “Fade” to titles
• Apply “Fly In” to pictures
• Apply “Zoom” to important points
Importance of Animations
Animations:
• Make the presentation attractive
• Increase audience attention
• Improve understanding
• Make slides look professional
However, too many animations can make the presentation confusing. So animations should
be used carefully.
Importance of Formatting Styles
Good formatting:
• Improves readability
• Makes information clear
• Gives a professional look
• Creates visual appeal
A well-formatted presentation leaves a good impression on teachers and students.
Tips for Making a Good Presentation
• Keep slides simple
• Use short points instead of long paragraphs
Easy2Siksha.com
• Add relevant images
• Use readable fonts
• Maintain same theme on all slides
• Use animations moderately
• Avoid too many colors
Conclusion
This question is mainly testing your creativity and PowerPoint skills. You are required to
prepare an informative presentation about your department and make it visually attractive
using animations and formatting styles. A good presentation should be simple, organized,
colorful, and easy to understand. Proper use of animations and formatting makes the
presentation more engaging and professional. By using text, images, themes, and animation
effects properly, you can create an excellent PowerPoint presentation that impresses both
teachers and classmates.
8. (a) How do you create a chart using a set of data in Excel?
(b) Explain the purpose of a Pivot Table. How can it be used to analyze data?
Ans: Part A: Painting a Picture with Excel Charts
A chart is simply a visual representation of your numbers. Instead of forcing your audience
to read a table of sales figures, a chart lets them instantly see that sales skyrocketed in the
summer and dipped in the winter. It turns math into a picture.
How to Create a Chart in Excel
Creating a chart is surprisingly simple once your data is organized. Let’s imagine you are
running a very successful neighborhood lemonade stand, and you have been tracking your
profits for three months.
Step 1: Organize Your Data Before Excel can draw a picture, it needs to know what the
picture is about. You need to organize your data into clean columns and rows. For example,
you might have one column titled "Month" (listing June, July, and August) and a second
column next to it titled "Profit" (listing $50, $120, and $80).
Step 2: Highlight the Canvas Click and drag your mouse to highlight all the data you want to
include in your chart. Make sure you highlight the column headers ("Month" and "Profit") as
well! This is a crucial step because it tells Excel exactly what to name your chart and how to
label the information.
Step 3: The "Insert" Tab Look at the ribbon menu at the very top of your Excel screen and
click on the Insert tab. This is your toolkit for adding anything new to a spreadsheet.
Easy2Siksha.com
Step 4: Choose Your Chart Type In the middle of the Insert ribbon, you will see a "Charts"
group with lots of little icons. Excel gives you several ways to tell your story, depending on
what you want to show:
• Column or Bar Charts: Perfect for comparing different items side-by-side (like
comparing who sold more lemonade: you or your brother).
• Line Charts: The absolute best choice for showing a trend over time (like watching
your profits rise from June to July).
• Pie Charts: Great for showing parts of a whole (like what percentage of your
customers bought classic lemonade versus pink lemonade).
If you aren't sure which one to pick, Excel has a brilliant button called Recommended
Charts. If you click this, Excel’s built-in artificial intelligence looks at the data you highlighted
and says, "Based on these numbers, here are the three charts that make the most sense."
Step 5: Customize and Polish Once you click a chart type, it will instantly appear on your
screen. But you aren't done yet! You can click on the chart title to rename it (e.g., "Summer
Lemonade Profits"). You can change the colors, add data labels so the exact numbers float
above the bars, and adjust the design to make it look professional.
Part B: The Magic of the Pivot Table
While charts are great for visualizing a small, clean set of numbers, what happens when
your lemonade stand becomes a global empire? What if you have a spreadsheet with
50,000 rows showing every single cup of lemonade sold across 50 different cities over 5
years?
You cannot just highlight 50,000 rows and click "Insert Chart." It would be a messy,
unreadable disaster. You need a way to summarize that massive pile of data first. Enter the
Pivot Table.
What is a Pivot Table?
Think of a Pivot Table as a magical, shape-shifting summary machine. It allows you to take
an enormous, complex table of raw data and instantly extract meaningful summaries
without ever having to write a single complex math formula.
The word "Pivot" is the key. To pivot means to turn or rotate. A Pivot Table allows you to
"turn" your data around, looking at it from different angles until the answers reveal
themselves.
How Do You Use It to Analyze Data?
Let’s go back to your global lemonade empire. Your massive spreadsheet has columns for
Date, City, Flavor, and Revenue. Your boss asks you a deceptively simple question: "How
much total revenue did we make on Pink Lemonade in Chicago last year?"
Easy2Siksha.com
Finding that manually would take hours. With a Pivot Table, it takes five seconds. Here is
how the analysis works:
1. Inserting the Table: You click anywhere inside your massive data set, go to the Insert tab,
and click PivotTable. Excel opens a blank canvas on a new sheet and gives you a "Field List"
on the right side of the screen. This field list contains all your column headers (City, Flavor,
Revenue).
2. The Four Magic Quadrants: Below the field list, there are four empty boxes. Analyzing
data is simply a matter of dragging and dropping your fields into these boxes:
• Rows: If you drag "City" into the Rows box, Excel instantly scans your 50,000 rows,
removes all the duplicates, and gives you a neat, single list of every city you operate
in down the left side of your screen.
• Columns: If you drag "Flavor" into the Columns box, Excel puts your flavors (Classic,
Pink, Strawberry) across the top of the table.
• Values: This is the calculator. If you drag "Revenue" into the Values box, the magic
happens. Excel instantly calculates the total money made for every flavor in every
city and fills in the grid.
• Filters: If you drag "Date" into the Filters box, you can tell the table to only show you
the data from "Last Year."
3. The "Aha!" Moment of Analysis: In just four clicks, you have summarized 50,000 rows.
You can look at the intersection of "Chicago" and "Pink Lemonade" and instantly give your
boss the exact number.
But the true power of analyzing data with a Pivot Table is how fast you can change your
mind. What if your boss suddenly asks, "Actually, forget the cities. Which flavor is our best
seller overall?"
You don't have to start over. You simply grab the "City" field, drag it out of the box to throw
it away, and the table instantly recalculates to show only the grand totals for the flavors.
You are pivoting the perspective. It allows you to ask your data questions, test hypotheses,
and find hidden patterns dynamically. You can spot that strawberry lemonade sells terribly
in winter but amazingly in spring, allowing you to make smarter business decisions.
Ultimately, Excel is much more than a digital filing cabinet. By mastering charts, you learn
how to present data so others can understand it. By mastering Pivot Tables, you learn how
to interrogate data so you can understand it. Together, they turn you from a passive data
collector into an active data analyst.
“This paper has been carefully prepared for educational purposes. If you notice any mistakes or
have suggestions, feel free to share your feedback.”